Stored Procedures [dbo].[BAECartEventFunctionUpdate]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@CartEventFunctionIDint4
@CartEventIDint4
@FunctionCodevarchar(32)32
@Quantityint4
@Titlevarchar(128)128
@Pricemoney8
SQL Script
create procedure [dbo].[BAECartEventFunctionUpdate] @CartEventFunctionID as
int,
    @CartEventID AS int,
    @FunctionCode AS varchar(32),
    @Quantity AS int,
    @Title AS varchar(128),
    @Price AS money
AS
    UPDATE CartEventFunction
    SET CartEventID = @CartEventID,
    FunctionCode = @FunctionCode,
    Quantity = @Quantity,
    Title = @Title,
    Price = @Price
    WHERE CartEventFunctionID = @CartEventFunctionID;

GO
Uses